package com.pay.game.central.web.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

public interface TestMapper {

    @Select("select ps.order_limit `limit`, sum(pg.done_times) times  from pdd_store ps join pdd_goods pg on ps.id = pg.store_id " +
            "where ps.id=(select store_id from pdd_goods where id=#{goodsId}) " +
            "GROUP BY ps.id")
    Map getStoreOrderLimit(@Param("goodsId") String goodsId);
}
